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