View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 [25] 26 27 28 29 30 31 32 33 34 35 36 37

  1. xp_sendmail problem
  2. SQL Server 2000 2GB memory limit?
  3. Formating Numbers with Commas
  4. Formating Numbers with Commas
  5. How to synchronize 2 tables on different sql servers
  6. Constructing Email message
  7. SQL Replication
  8. Does DB-Restore on a different machine omit user/login information ?
  9. SQL DTS package to process a remote OLAP database
  10. How To set delimeters and text qualifiers in a file
  11. How To write An Sql Crosstable Select statment
  12. How To write An Sql Crosstable Select statment
  13. Using DTS to move data to a new table with some datatype changes
  14. HexToInt, vbintoHexStr - fun with CAST
  15. how to add 1 to the field
  16. Help with SELECT Query
  17. Is this correct use of INSTEAD OF Triggers?
  18. Tunneling enterprise manager over https ASP.NET?
  19. Conecting over the Internet for getting data from clients.
  20. Number Data Types...
  21. openrowset - problem in reconnecting to oracle
  22. Help ! Database Still says loading after restore
  23. Help ! Database Still says loading after restore
  24. Select JOIN problem
  25. Wrong syntax in where smth in case ?
  26. Query Analyzer Template files, object browser bug
  27. wil s2k developer edition really work on XP Pro box?
  28. SQL Profiler
  29. DTS of data between two tables, same field names but differnt datatypes
  30. Sending external email from within a Scheduled Job
  31. What is purpose of N in SQL examples?
  32. cursor insert with like '%'
  33. DTS vs Datastage or Informatica
  34. Connecting for entire session, or just when performing an operation?
  35. How do you lock an entire table?
  36. Crosstab queries
  37. User interaction with SQL
  38. BULK INSERT row terminator
  39. Help Please - Backup FileGroup and Restore
  40. MDX Query Book
  41. Stored Proc not updating multiple rows
  42. DBA on mulitiple databases
  43. 7.00.1078_enu.exe on msde
  44. Problem returning a datarow
  45. Storing binary files in MS SQL 2000
  46. simple SQL update
  47. How can I INSERT w/Constraints in other tables?
  48. SQL 2000 - 450+ Databases
  49. Loop through a recordset to populate columns in a temp table
  50. HexToInt and HexToSmallInt
  51. update from ...?
  52. SQL update statement in VB
  53. Field not being updated within Stored Procedure
  54. Complicated SELECT Problem
  55. Book and class
  56. How to delete rows in a table when no primary key is defined
  57. Primary key
  58. Database Modelling in UML
  59. Mails are stuck in the Queue Folder
  60. odbc errors on terminal server
  61. XML to View
  62. SQL problem
  63. DTS package doesn't execute
  64. Totally shameless self-promotion
  65. Sql server authentication not set
  66. Error while running xp_cmdshell
  67. timeout expired w/SQL2K SP3
  68. any SQL guru's out there?
  69. DEFRAG disk drive
  70. Need good idea
  71. Problem using CAST with Zeroed out Field Values
  72. How can i get the details of the error
  73. Very large number of rows
  74. Will MSSQL DB Server perform better with 2k3?
  75. Database design, inherit
  76. How to get the status?
  77. User-Defined string Functions Transact-SQL
  78. Changing the default port number and still connecting
  79. Need advice for process of swapping DBs
  80. How to convert recursive function into recursive stored procedure
  81. Crosstab query
  82. Database Backup Security
  83. Separate an And/Or parameter
  84. Best way for a Set-based query
  85. Recovery and Backup
  86. ODBC and MSDE
  87. Customer IDs without identity
  88. SQL Server -> MS- Access VBA
  89. persisting data for a pluggable tree
  90. What hardware to get?
  91. generating auto sequential numbers
  92. case, joins and NULL trouble
  93. PRIMARY Files
  94. Install Client Connectivity (SQL Server 2000) Only w/ Less Files?
  95. Write only database
  96. sp_elpuser rights
  97. Mail Profile disabled in SQL Server Agent Properties
  98. Linked Servers - Postgres 8.0.2
  99. Ignore Triggers
  100. checking success of a request in a stored procedure
  101. Session State InProc. HELP??????
  102. can't print variable
  103. Timeout Expired Error
  104. Monitoring Data file size
  105. Splitting of database
  106. don't permit manual access to database
  107. Frontpage 2002 & passing an SQL variable
  108. Snapshot replication
  109. SQL - query improvement MAX(date), IN
  110. Problem with dbo.sysindexkeys in SQL 2000
  111. Creating a trace file with the date appended to it's name
  112. SQL Server & MSDE on same machine?
  113. Help with DTS script
  114. Linking Two SQL Servers
  115. Can I ghost an SQL server?
  116. Tables get Locked
  117. MS SQL 2005 Express
  118. Count of related records??
  119. Net Send Failure
  120. Monitoring Deadlocks
  121. Best way to create dynamic update statement
  122. Edit .mdf database
  123. importing a .txt file
  124. SQL Backup procedures...
  125. Installing MSDE2000 for Remote Connection
  126. Noob: Why does this Query work?
  127. concatenate where clause
  128. Moving db across the country- full copy, then differential?
  129. Inserting Records with limited privileges
  130. Scripted delete rows
  131. SCOPE_IDENTITY with ASP
  132. A query that chooses non-matching items
  133. Counting based on a field combination
  134. SQL Server Hot Fix Install Error - dbmslpcn.dll is WRITE LOCKED
  135. Enterprise Manager Collision
  136. Views Are Deleted
  137. quey help
  138. Storing a month
  139. Storing a month
  140. problem with OUTPUT params in Stored procedure
  141. not exist in place of outer join
  142. Dates incorrectly being saved incorrectly. DD and MM swapped round ?
  143. Primary key on combination of nullable fields, at least one not-null
  144. SQL statement
  145. create database at shared hoster site
  146. Refresh data from production to development
  147. SQL datetime from incorrect char(10)
  148. Interesting Problem
  149. SQL Server on Windows XP Workgroup
  150. paradoxical query results?
  151. Int versus Char primay key performance
  152. Tables seem too big - timeouts happening
  153. SQL Server Distribution Server Licensing
  154. SET FMTONLY being added to in-line SQL
  155. Proyectos de Inversion en IT en la UTN
  156. what does [dbo].[Accounts] mean?
  157. web hoster only allows 1 sql server database
  158. problem in registering sql server in enterprise manager
  159. query result as comma-separated list
  160. Last edit time?
  161. Installation Issue
  162. compare
  163. Question with filegroups
  164. help with query
  165. I need help connecting Access 97 to SQL Server 2000
  166. IsNull Evaluation within EXEC
  167. Parameters in Reporting Services
  168. Database Environment Naming Production -vs- Development
  169. restore from command line
  170. SQL to find short, fat and stupid people
  171. Strange Problew with user defined function or stored procedure
  172. Get lowest date
  173. How to reinstall RS Standard Edition on top of expired RS Eval edition
  174. Format display of current row
  175. Connecting Access Front End to Remote SQL Server
  176. Connecting Access Front End to Remote SQL Server
  177. Modifing the row that invokes a trigger from within that trigger
  178. instead-of trigger and contraints
  179. Advantage of Temp Table
  180. VBScrip Type Mismatch Error
  181. Diagram of Master DB
  182. Linked Server gives Internal SQL Server error
  183. prevent DELETE and/or UPDATE
  184. binding SQL server to localhost?
  185. Cache HIT ratio problem
  186. Would you please suggest a good backup tape drive?
  187. Verify dynamically specified table exists
  188. command line
  189. DBA HELP: Performane Tune SELECT, SUM, & CASE
  190. QA tells me my table is ambiguous
  191. Breaking up a Table
  192. query analyzer returning messed up data
  193. Call DTS package from VBA/Excel?
  194. MS SQL Server 2000 / MS Access - ODBC connection question
  195. Lost My Diagrams
  196. New SQL Server and Photos
  197. I dont have any backup of my database, but I have the mdf's and ldf's files
  198. How to get parameter passed to SQL query from access
  199. Creating a view from a linked server
  200. How to comment a server template
  201. How do ITables moved to a new FileGroup ?
  202. Sum of hours by week
  203. Destination Columns Question
  204. Remote access to sql database...permissions
  205. Using MSDE and moving databases
  206. Help! Cygwin X slows down Query Analyzer
  207. How to copy db from test server to local machine running MSSQL2000 Per.
  208. Inserting a record for each separate aggregate (solved)
  209. Import RIS format to SQL Server?
  210. Run DTS in safe way.
  211. Neq to SQL
  212. How to fetch or store a BIGINT using dbExpress and Delphi 2005
  213. Deadlocks in Profiler
  214. DBCC SHOWCONTIG inconsistency????
  215. Access Violation on Saving a DTS Package
  216. Assistance developing Query
  217. Convert variable into dynamic select
  218. Windows groups for SQL Server - what am I doing wrong?
  219. Run DTS package
  220. Primary Key
  221. Move mdf/ldf files for a replicated database
  222. Gather Meta Data
  223. Checking datatypes of a field accoss multiple tables
  224. How to call functions via ODBC
  225. Learning SQL Server 2000
  226. Date problem in SQL Server
  227. Data Parsing in SQL Server views
  228. Changing collation for tempdb and model
  229. Changing collation for tempdb and model
  230. Changing collation for tempdb and model
  231. Design Problem...Please Help!!
  232. Char to Bit
  233. SQL Server Agent - E-Mails
  234. Help with update query linking 3 tables
  235. sp_configure missing - need to allow updates!
  236. Alias has confused me.
  237. sp_configure missing - need to allow updates!
  238. time-series SQL code.
  239. Log Shipping Transaction Log Question
  240. 100,000 lock requests/sec
  241. [TRANSACT]Can't switch from master to another database
  242. "Users shopping for A were also interested in B"
  243. SQL Server Query Optomizer
  244. xp_logininfo and Domain Local groups
  245. "Unable to validate product key"
  246. Help with JDBC Driver
  247. Object Owners.
  248. Compare data in Tables
  249. MS SQL Server 2000 Log Shipping problem
  250. Getting error c:\windows\system32\odbcad32.exe error
  251. International Motivation Survey
  252. Need one Query to obtain results I can only get with two queries
  253. Transaction Replication & Data archiving on SQL server 2000
  254. SQL gurus, please help
  255. Connection problem from Access front end application to SQL Desktop Engine backend
  256. Strage characters displaying in Enterprise Manager 2000
  257. Return Type of COALESCE?
  258. Strage characters displaying in Enterprise Manager 2000
  259. Using DTS Global variable in task
  260. Creating a Select statement with subqueries to 3 other tables...
  261. SQLDMO - Operating System Cannot Run %1
  262. Microsoft Access doesn't support design changes to the version of Microsoft SQL Server
  263. Seaching mulitple fields?
  264. Importing txt files with sql server 2000
  265. Do's and Don'ts of SQL
  266. Reorganize data and index pages
  267. Unhandled exception in mmc.exe: : Access violation
  268. How to solve "Tables or functions 'inserted' and 'inserted' have the same exposed names. "
  269. Openings in an online game company for sql coders
  270. Return results of mulitple select statements in another Stored Procedure
  271. Query runs slower when converted to a view
  272. Poor performance for business day calculation from aspfaq sample
  273. Database design
  274. Limiting active processes?
  275. Delete with 2 keys
  276. Example of Internal SQL Server Error
  277. SQL Server Best Practice Analyzer and T-SQL coding standards
  278. Merge results from two fields
  279. Problems with joins
  280. Big table
  281. How to assign string value to TEXT output parameter of a stored procedure?
  282. Using an if statement
  283. parameterized pass-through queries from Access front-end?
  284. Optimization of a select query
  285. Maintenance Microsoft
  286. A little script help
  287. SQL Server Backup Applications
  288. HELP PLEASE. Query Question.
  289. Help with a Join and Duplicates?
  290. How to extract part of a string
  291. How to upgrade a stored procedure this way?
  292. Help with dynamic SQL Stored Procedure
  293. SubQuery or Temp Table?
  294. Database Design
  295. Inserting data to tables belonging to different databases
  296. howto check the sql server edition from code
  297. Paper about SQL Server 2005
  298. New to MS Sql
  299. Data transfer
  300. Convert a existing SQL Server 2000 database to 2005
  301. System DSN / Registry
  302. SQL SERVER DBA/ ATLANTA
  303. relation & query
  304. remote stored procedure on MSDE
  305. Fastest way to handle the search
  306. naming column names
  307. help on query
  308. MSDE installation fails due to detection of previous installation
  309. Table size and Computed Columns
  310. trying to avoid using cursors!
  311. How to Go From a Database to A Calendar Format?
  312. Help with 1205 Not raised
  313. cursor vs. select
  314. ASP + SQL loads really slow over intranet
  315. Insert produces error
  316. HELP - SQL Server 2000 Install Files needed urgently
  317. User input in SQL2000
  318. Can stored procs run after handle is closed?
  319. Restore Log Fails Msg:3433
  320. Date Display
  321. Error on link Servere
  322. Dev. Team - Keeping Three Tiers in Sync
  323. How to add 2 columns together
  324. SQL 6.5 migrating to SQL 2000
  325. Import XMS into SQL Server 2000
  326. NTEXT vs NVARCHAR for large number of columns
  327. Crear una BBDD desde VB.NET
  328. Memory Mgt in SQL SERVER
  329. Enterprise Manager Date format has changed
  330. Copy a database
  331. How to backup a database into a number of smaller files ?
  332. loop through a datagrid
  333. SQL Like.
  334. MS ACCESS - ON DELETE CASCADE Problem
  335. Query Optimization
  336. sp_send_cdosysmail - Parameter Inside Body of Email
  337. can't do that request
  338. owner of a temp table
  339. Accomodating 'Dummy' Data?
  340. Problem with query and date ranges
  341. Error processing cube with disabled lowest level of shared dimension
  342. Locking Problem: SQL Server
  343. How to copy tables from local machine to remote SQL server
  344. isql error message
  345. Dynamic Build SQL in store procedure based on select
  346. bcp is inserting blank space for empty string
  347. Is it ok to use 100% of SQL Server CPU?
  348. SQL 6.5 - to - SQL 2000 replication
  349. parse XML strings in SQL text field
  350. 3 quick queries
  351. Insert value in an auto-identity column
  352. My db grew 8.2GB in two weeks BUT only 4MB of data added
  353. INSERT violates primary key. Which way out?
  354. Cannot Generate SSPI Context
  355. Distributed transactions with multiple instances of Microsoft SQL Server
  356. email on insert
  357. Enter Default Values for all columns in all tables except Primary Keys
  358. update fields with searched first date record fields
  359. SQL Query Help
  360. Re-using a calculated sub-select field in a view?
  361. What is wrong with this procedure?
  362. help with santax
  363. How can i copy data
  364. Copy field data from table to another
  365. (((((((((( Anyone know where I can pickup MS SQL 02? ))))))))))))))))))
  366. ((((((((( Can someone post SQL 03 program ))))))))))))))))))
  367. NULL values and Indexes
  368. Installing Without CD - Help
  369. Obtaining business hours based on start and end date
  370. Domino VBA
  371. Domino VBA
  372. Is Physical server name stored in the Master database
  373. Renaming logical file names
  374. Utilizing compound indexes
  375. Converting tables to Upper case
  376. Selecting single sorted row from many column
  377. Profiler Trace file format
  378. Join using max value
  379. ZZZZ New text 1/1 New Text Document.txt (1/1) 18
  380. ZZZZ New text 1/1 New Text Document.txt (0/1) 18
  381. filelistonly vs verifyonly
  382. How to connect using C#
  383. audit trail triggers
  384. Checksum not working
  385. Exam 70-229
  386. exec sp_executesql vs. sp_executesql and performance
  387. Need help in Updating multiple rows
  388. CHECK Constraint to prevent a conditional duplicate
  389. Transaction MS SQL
  390. SQL Enterprise Manager and Query Analyzer displaying different Row Counts
  391. Database definitions
  392. urgent
  393. Oledb stored procedure rowset binding
  394. GROUP By clause or DISTINCT clause
  395. Specific Book Recommendation
  396. Question on using patindex
  397. Server not using all available memory.
  398. Grouping columns
  399. Importing Access databases into SQL Server
  400. What is Cardinality
  401. 'Suspect' DB won't open - OS error 32- Help!
  402. Inserts gradually slow down
  403. Need help with complex(?) querie
  404. SQL Union with ORDER BY
  405. isqlw.exe
  406. Restore Production database to Development
  407. Duplicate Reference Numbers using MAX()+1
  408. sql charindex split string
  409. Determine Quarter End and Beginning Dates
  410. owner data objects
  411. Transaction log shrinking... weird behavior?!?!?!?
  412. SQL Server: command line support
  413. Connecting to SQL Server 2000 on another subnet
  414. Count consecutive numbers
  415. Front-end website search using Full-Text
  416. local data
  417. .RMD or RMX. to sql server
  418. Which is better? Int or smalldatetime(MSSQL)
  419. SQL Server 2000 and Windows Server 2003
  420. Many databases vs. 1 database
  421. a new SQL tool to help maintain SQL code is now out
  422. a new SQL tool to help maintain SQL code is now out
  423. Restore database fails because database is in use.
  424. More on mysterious data loss in mssql2k - a possible solution?
  425. read only database performance question
  426. Dynamic Column amount query
  427. Can someone explain this behaviour?
  428. top keyword and sorting
  429. can't do that request
  430. Count the number of cubes
  431. Column Names with a cursor
  432. Sample ASP Script??
  433. Database backups growing exponentially
  434. sql service run as question
  435. How To PROTECT SQL Server Database Files ?
  436. Database Move
  437. Mysterious loss of data from mssql2k
  438. Great News Blog!
  439. Query problem
  440. Having Trouble Installing Reporting Services
  441. Help with query
  442. Interesting issue with Full Text Search
  443. Tough little trigger
  444. SQL Server Performance
  445. Need help with SQL query
  446. Virtual Server 2003 Issue! Access Denied- Admin web screen !!
  447. Process not getting any memory
  448. Dropping FK Constraints in a Stored Procedure
  449. C#, SQL-DMO, Add FileGroup Issue.
  450. Insert SP results into variable?
  451. No longer need default instance of SQL Server
  452. basic sql question
  453. SQL Server 2000 Table Auditing for HIPAA
  454. Log Shipping Problem
  455. sql server replication performance
  456. Recursive Query ??
  457. Getting SUM Function Result
  458. Executing sql statements
  459. Syntax for updating table variables
  460. Handle SQL errors with severity 10
  461. Timestamp problem!
  462. Error 15401 adding login to SQL Server
  463. SQL database structure question
  464. How display number records in query designer VisualStudio.NET
  465. help on a sql request
  466. Views / Stored Procedures / Updating Records
  467. Compairing updated data base.
  468. Calling Encrypt2 function from Sqlserver select query
  469. manage transaction to avoid locks
  470. Virtual Primary Key = Slow
  471. SQL Server Scalability
  472. SQL Mail
  473. Help! SQL Server error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ...
  474. access 03 query datashet view problem help
  475. Combine two queries - help please
  476. Import Password Protected File Via DTS
  477. using count somehow
  478. Is it possible to write a format file that skips a few bytes of header in data file?
  479. How do you export?
  480. Dataset Code Debugging
  481. Altering functions and CHECK constraints
  482. Results of SQL SELECT statement into Stored Procedure
  483. Server Reboot
  484. Replication Problem
  485. View Optimization?
  486. SQL Connections using NAT
  487. Updating a field for multiple records
  488. C#: Running DDL to Create Functions.
  489. search engine in SQL server ?
  490. slecting a table using a local variable name
  491. Need help with query that does both timediff & sum
  492. copying data and structure from one database to another
  493. Please help: Create View
  494. Please help: Create View
  495. stored procedure question
  496. Inserting multiple rows with a single INSERT INTO
  497. Cacluated Field
  498. smalldatetime and sorting
  499. Derived Fields
  500. To compare fields between two table
  501. union with sub query
  502. Data import - foreign key question
  503. urgent DB export issue
  504. Vote on a new newsgroup proposal
  505. Windows 2003 - SQL server does not exist or access denied
  506. T-SQL Help
  507. Unable to create a step in a SQLServer Job
  508. Can't connect to SQL Server (developer edition) from another PC?
  509. Help with java connection to MS SQL 2000 with windows integrated security
  510. automatic rename in FROM clause of dependant objects ?
  511. typical audit trail ?
  512. difference between SYSTEM_USER and USER
  513. How to find max from a table by row
  514. HELP: REGEXP accurences count
  515. Inserting to table with dashes in fieldnames
  516. Calculate/create Row Number without identity
  517. sp_attachdb time varies
  518. Exists query with priorities
  519. Date range problem
  520. BCP and Bulk Insert to Linked Servers
  521. How to simplify my endless query. Thanks.
  522. question on trigger/procedure plz reply?
  523. Question on FOR XML issue
  524. sql query help
  525. Help with SQL if statement and adding fields together
  526. treat contiguous records as 1
  527. quick question on SQL server and object support
  528. Null How to handle
  529. Table Design Question
  530. Stored proc location
  531. Change data type during INSERT INTO ?
  532. Urgent
  533. Finding last "whitespace" character in a string?
  534. Question on Idenity Columns
  535. How to handle this Linked Server error trap in SQL2K?
  536. Setting up backups
  537. Parse a numeric string from a field
  538. updateblob
  539. Switched to simple recovery model when will the transaction log shrink?
  540. limiting result set from MS SQL Server Query
  541. How to get info in SELECT directly instead of UPDATE? Thanks.
  542. Can you qry sys tbls to find Triggers, Constrants etc?
  543. How to build database to support user-specified entities and attributes?
  544. Poor performance
  545. working with xp_sendmail
  546. AND query in single column
  547. Stopping a script
  548. How to get a batchjob to run on more than 1 processor ?
  549. SQL Query to return rows only when a max limit on SUM has been reached.
  550. dynamicall execute SP without dynamic sql