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. Get next unique ID from a table before insert @@identity / Sequence
  2. Sum fields
  3. Exatract Data, thanks.
  4. change license mode on SQL 2k cluster
  5. change license mode on SQL 2k cluster
  6. How do you execute an Oracle Stored Procedure from a SQL Server DTS package?
  7. Other than UNION
  8. Query help -- extract data, thanks!
  9. isnull and ntext variables (short question)
  10. Easiest way to copy a MS-SQL Database from one machine to another
  11. "IN" clause limitation
  12. change to not allow nulls
  13. Converting DateTime
  14. EXEC stored procedure for every line of SELECT result table - how?
  15. sp_executesql & Output Variables. One Ball#$#%% of a problem.
  16. Help with WHERE Clause in Stored Procedure
  17. rollback via query analyser
  18. Handling Schema Changes
  19. Trigger
  20. BULK INSERT - does it lock the file while reading?
  21. How to convert from ntext to float?
  22. REPLACE ISSUE..
  23. SQL Server 2k - Timezone question.
  24. Updating the same column multiple times in one update statement
  25. Repeating Records!
  26. SQL Server DBA needed for Florida-US
  27. How to apply complex constraints
  28. SQL Reporting Services PDF Chinese Characters Problem
  29. Simple SQL help needed
  30. How to compare Binary and Int colns
  31. Performance -- count(*)
  32. How to build database to support user-specified attributes?
  33. query to fetch data
  34. Moving a database from one machine to another and the lack of speed
  35. Replication Question about job names and categories
  36. External Access
  37. Very unhappy front end developer looking for advices
  38. Record count in all tables
  39. Can SQL Server 7.0 handle a SQL Server 2000 mdf?
  40. low cost method to check database before inserting data
  41. Import data from Adaptive Server Anywhere 7 DB
  42. MULTI-Table Update Queries
  43. stored procedure varaiables
  44. Code page translations are not supported for the text data type. From: 1252 To: 950.
  45. Active directory query 1000 page size limitaion
  46. Java against SQL Server
  47. problem making Oracle linked server work
  48. SQL Server 2000 vs. MSDE
  49. Need Trigger Help
  50. Using Access with SQL Server
  51. trigger event after time period
  52. CHARINDEX and STUFF/REPLACE
  53. IF..ELSE in function - unknown error
  54. Db installation
  55. long time to establish a connection
  56. Connection string for the Ms-SQl Server using ASP.net
  57. Question: changing case on existing records
  58. SQL Server 2000 Book Recommendations? Including Good Coverage of Reporting Services
  59. Pivot Chart Value Axis Scaling Question
  60. Sql query timeout, expensive cast operation?
  61. Single complex INSERT or INSERT plus UPDATE
  62. Outer Join - shifting result set.
  63. How does SQL 2000 Server back up user database?
  64. creating a new numbered column as primary key in a table
  65. best way to compile thousands of TSQL stored procedures?
  66. Where do views and SP's execute?
  67. Default base
  68. sp_spaceused
  69. Query Help, thanks!
  70. getting english column names into a german database
  71. Can't register local instance of SQL Server on local server PLUS
  72. Usability Evaluation Study n570
  73. Need help with creating view
  74. SQL Server concatenation error
  75. UPDATE ORDER BY error
  76. DTS Restore from a file
  77. DTS package with unexpected issues
  78. SQL Report/View
  79. Can't register local instance of SQL Server on local server PLUS
  80. Alert on data deletion
  81. data types
  82. Importing .txt to SQL
  83. problem : random error with with IIS6 and MSSQL
  84. SqlServer2000: autonumbering records - how to ?
  85. Asignar a una variable el valor de un campo
  86. How to enable TCP/IP connectons to SqlServer
  87. Ordering, Grouping - HELP!
  88. auto numbering
  89. SQL 2K Backup Log Monitoring
  90. SQL 2005 Integration Services Help
  91. Performance mystery -- SP vs script
  92. Database Restore Woes
  93. SQL Server 2K problem with fractional real values
  94. Query Help, thanks!
  95. Transforming rows into columns
  96. Script to restart replication
  97. How can I find what tables are loaded in memory ?
  98. Windows 2000 Server / IIS / SQL Server 2000
  99. why does a user function require dbo.* and a stored proc does not?
  100. DTS import does not import all rows / records
  101. Query not using index
  102. Table lock
  103. Senior Infrastructure Database Administrator - Calgary, Canada
  104. "Storing an image into Sql Server Database "
  105. Convert Seconds to hours:minutes:seconds
  106. SQL 7 SP 4 Installation Hangs
  107. Connecting to SQL Server from ASP
  108. SQL Statement Tuning
  109. Cloning a table
  110. debugging stored procedures
  111. Enabling Microsoft EFS in a SQLServer 2000 Cluster
  112. character sets in SQL server
  113. collate SQL_Latin1_General_CP850_BIN to SQL_Latin1_General_CP1_CI_AS
  114. syntax question whole word finding
  115. SQL Connection Log
  116. Stored procedure deadlock on self with subquery
  117. Insert Into Column problem ...
  118. T-SQL too big for Task Scedule - HELP!
  119. Using LIKE with underscore and forward slash..
  120. Identity In SQL VS Autonumber In Access
  121. Client connection to SQL Server on shared hosting
  122. SQL Statement Help
  123. Speed cost for using "or" clause and functions on join statement
  124. Design question: Nested views and functions?
  125. various working with dates issues
  126. Another DTS question
  127. Update query
  128. Lock:Timeout events
  129. slow performance on specific query
  130. curious result
  131. Anyone interested in getting Microsoftt, CISCO or any other IT CertificationzzzZ
  132. Help, im new to MSSQL
  133. Asking Email Address Up David Portas and Erland Sommarskog
  134. SQL Server/PeopleSoft DBA Needed!
  135. Is there a way to autoincrement a field with mixture of alpahbetic characters and numbers?
  136. Stored Procedure Not Returning Recordset in ASP
  137. SQL Server on chared hosting with client connections
  138. Column calculations
  139. Database performance degrading (again)
  140. Permutate rows based on table
  141. BCP Issue w/Right Truncation
  142. SQL 2000, AS400 and Client Access
  143. Get the field value after INSERT
  144. Question on aggregate statement
  145. Query/Report Help needed
  146. Stand alone client tools installation
  147. Mystery Database IDs in Profiler
  148. Query - check for a string in stored procedure
  149. Report Containing Sequential Dates (removing date gaps)
  150. Update Time Out?
  151. MS SQL Server - User Rights
  152. Null & String Ops Again
  153. Login Confusion
  154. SQL Query - Aggregate data
  155. Script to lock down a regular user?
  156. Concurrency issues with "Tree" structures.
  157. get the description of a column
  158. Problem backing up Database and Transaction Log due to disk space limitations
  159. TSQL: I want to use a SELECT statement with COUNT(*) AS 'name' and ORDER BY 'name'
  160. Complex query help needed....
  161. DTS Package and ASP.NET
  162. Urgent deliverable
  163. Update Query
  164. How to remember last record read
  165. multiple foreign keys on same field, based on other field
  166. ASP to SQL Connection Prob, Same Server, IIS
  167. Using select results in a stored procedure
  168. DB2 User Group Italy - next meetings March 2005
  169. simple division problem
  170. How to Backup Read-
  171. How to Backup Read-Only databases
  172. Dr. Michael Rys on Microsoft SQL Server 2005 and XQuery
  173. Cannot Drop Database
  174. Select first type problem...
  175. 'NETWORKDAYS(start_date,end_date,holidays)' in SQL ?
  176. Database design question
  177. A Query-Transpose of Data
  178. Some Queries
  179. Delete data, but file size increase
  180. Log all commands executed in QA
  181. Profiler not reporting reads accurately
  182. SQLServer Redirector Port 1434
  183. Get list of files in directory using a SP
  184. SQL Monitoring
  185. Format result of sp_helpdb
  186. backing up read-only database
  187. Conversion between Date Formats
  188. Conditional JOIN
  189. Timeout expired
  190. execution plans
  191. list of databases in Analysis Services
  192. Full Text Indexes do not fully populate
  193. About SQL field Type
  194. New Question Regarding LOG SHIPPING & MASTERDB
  195. Looking for MCDBA certified individual with a TS/SCI Clearance
  196. using DTS question
  197. Slow SQL Query - Case in Where Stmnt
  198. Help needed to improve the performance of the query
  199. SQL Server reports
  200. Can I EXPORT tables to a backup DB and delete them from my production server?
  201. How to remove WITH FILLFACTOR = 100 when Generate Sql Script ?
  202. How do I get uppercase values returned only.
  203. BCP Beginner - Please Help
  204. Failing replication requiring restart of SQL Agent
  205. aggregate sql question
  206. DataSet Update Problem
  207. Pivot table not showing blank value column ...
  208. Problem with Excel Pivot Table
  209. Security and access rights using local and global groups
  210. Best practices for field sizes
  211. sp_executesql vs. stored proc.
  212. sp_executesql vs. stored proc.
  213. Tricky group by order by query
  214. Tempdb gets out of control when inserting records
  215. How to create a new serverinstance but with old datafiles?
  216. [DBNETLIB]ConnectionCheckForData (CheckforData())
  217. forcing dbsqlexec to exit cleanly
  218. Stored Procedure and multiple keys which could be NULL
  219. Efficiently joining same table twice
  220. Problem Installing SQL 7 or SQL SERVER 2000 on Laptop
  221. Converting Decimal to String W/O Decimal Point
  222. Help with update query please!
  223. BCP Format File
  224. BCP Utility - Skip rows..
  225. Importing CSV files
  226. MS SQL 6.5 Unable to connect.
  227. How to check when a stored procedure was last called/executed
  228. error 7965 not a valid recordset property
  229. Date query question!
  230. Simple select question!
  231. SQL-problem
  232. data transform and compare with in a query
  233. Parameterized order by clause: doesn't work
  234. 2 Questions: license Installation and Speed
  235. Spinning Image
  236. Need help / suggestion
  237. 2005 Express - Concurrent Connections
  238. passing a field name into a parameter
  239. Machine Name In Trigger
  240. Assigning column types in select into
  241. Delete rows in Excel From DTS package
  242. Key Lock Hashed Resource Text Value not unique?
  243. Importing Access DB
  244. [mssql][ant] Failed to execute: GO
  245. Syntax problem
  246. Syntax error in update?
  247. Update using an Inner Join
  248. Error with the trigger
  249. Sql Server Developers Licence
  250. Query to tranform rows to column
  251. Need help in log shipping
  252. Using SELECT LIKE with ADO Parameter in ASP Page
  253. access data in remote SQL server with trusted authority
  254. open query help
  255. orphan recods
  256. user defined functions & default parameters
  257. SQL DATEADD function
  258. What's a significant LockTimeout measurment in PERFMON?
  259. What's a significant LockTimeout measurment in PERFMON?
  260. Date Compare in SQL Server Stored Procedure
  261. Date Compare in SQL Server Stored Procedure
  262. Cannot DTS connect to SQL Server 2005
  263. Datatype
  264. Seek method, table-direct, and sql server2005
  265. pass hash (#) table with different structure to stored procedure
  266. Date Compare in SQL Server Stored Procedure
  267. Group by Problems
  268. list schema's of a sql server
  269. Question about SUM and Nulls
  270. SQL Query Help
  271. Auto-increment PK - Use MS or Grow your own ?
  272. Query Analyzer does not see Enterprise manager database and vise versa
  273. Find Missing data from table
  274. SP To create table
  275. T-SQL Cursor Variable..
  276. IF (SQL server)
  277. checking the existance of fields and types
  278. I need help with SELECT statement
  279. tab character
  280. Books on Data Warehouse Performance Tuning for MS-SQL 2000
  281. Backup - Solution Needed
  282. Email on insert in a table
  283. Question: Upper row limit of 6080 characters
  284. Bizarre case behavior.
  285. SELECT-how to get only the last 20 records?
  286. Will OSQL Produce SQL Backup?
  287. Can't Export Fields w/ over 255 characters
  288. Large binary writes slower than expected
  289. "Hill Climbing" -- a More General Question on Systematic SQL Skill Upgrade
  290. Import MS-Excel to SQL-Server
  291. Semistructured data
  292. looking for a tool/ middleware tool which...
  293. Win xp sp2
  294. Help needed
  295. Anyway to recover delete stored proc?
  296. Query help with 2 tables plus one more - easy I think
  297. SQL JOIN help
  298. SQL 2 tables ask
  299. IF statement in DML
  300. Creditwrench
  301. sql LEFT JOIN and IN question
  302. restore db stuck loading
  303. Multiple Table Joins Makes Query Go To Sleep
  304. SQL ask 2 tables
  305. Writing your own aggregate functions
  306. Using the same View repeatedly
  307. A story of incorrect syntax
  308. ASP.NET/IIS/SQL help !
  309. SQL Debugger Problem
  310. SQL Transaction Processing - Learning Resources
  311. Execute same statement for each value in result set
  312. Export
  313. Question:Killing sessions before nightly CHECKDB
  314. Question:Killing sessions before nightly CHECKDB
  315. SQLMail does not start
  316. stored procedures/security
  317. simple problem, it's friday...
  318. Return most recent membership based on year stored in joined table
  319. DB design thoughts??
  320. execute proc on stopping mssql server
  321. Having Clause won't run on Linked Server
  322. importing DB from another SQL server
  323. SOX Solutions?
  324. incompatiable data sync
  325. Sending file contents in the body of the email with xp_sendmail
  326. Cool File Encryption Software Released.
  327. VB and SQL Reporting Services
  328. ms sqlserver chat room
  329. Impossible to use a scalar UDF to pass a parameter to another UDF?
  330. How to build Gui or forms to wrap SQL queries that are normally run in query analyzer
  331. What's wrong with this View? Duplicate columns?
  332. VB6 connection problem to MS SQL Server 7 table
  333. Planning for SQL Server 2005: 64-bit, OS, processor, memory
  334. SQL Server Agent Job History
  335. Obtaining timezone offset in T-SQL.
  336. T-SQL script for tran log with - in database name
  337. Select * from something where field1 = N'literal'
  338. Agregar una tabla a un filegroup existente
  339. Select * from something where field1 = N'literal'
  340. language-font problem
  341. osql feedback
  342. Error converting data type varchar to float
  343. MS SQL connection could not be established
  344. Between Question
  345. SQL 2000 whitepaper?
  346. Merging Duplicate Rows
  347. comparing data between two tables...
  348. DLookup equivalent in SQL Server
  349. How to get the last occurence of rows containing disticnt value in one column
  350. Alternatives to SQL *Plus
  351. strtdb80.exe has encountered a problem
  352. searching for any data string in database
  353. SQL Server Backup
  354. Is user logged-on?
  355. Help optimising SQL Query
  356. accessing the database remotely from non-microsoft platform
  357. Select for Cursor Returns 0 Same Select Highlighted Returns 2,000+
  358. Quick SQL Server 7.0 index question
  359. How do I format an integer
  360. why does this deadlock?
  361. Capture Records That Failed Insertion From XML
  362. SQL Server 2005 Datetime data type
  363. How can I avoid table lock in SQL2000?
  364. @@servername returns NULL
  365. Odbc - binding sql server binary field to a wide char field only returns 1/2 the daat
  366. Help - Corrupted SQL Server 2K Log. Is this serious
  367. Access Data Projects Uniqueidentifier problem
  368. Find Table Size
  369. LogPI performance
  370. Moving log files
  371. Conditonal SUM function, or similar conditional aggregates
  372. As a Beginner's I'm having trouble finding a sample DB on which to learn to model my own.
  373. SQL Server Table Backup
  374. SQL 2000 Linked Server Hangs Due To Trigger
  375. How pass column to udf in join
  376. Validating and updating colums
  377. Managing DB updates to client DB servers
  378. Select data from table an return all all months
  379. Accelerating MS SQL Client
  380. Output an SQL Query to a text file
  381. SQL SERVER REPORTS ANALYST - Dallas
  382. Which Sql Server error number is used when a table has a deadlock?
  383. HOWTO: Installing SQL 6.5 on Windows 2000 Server
  384. Very strange behavior of SQLServer with connection from CGI
  385. Conditional summaring
  386. Finding out all the User Tables being used by an application
  387. Performance decrease after OS upgrade
  388. Need help speedig up query
  389. CRecordset + char + stored procedures inoutParam
  390. Shrinking database files
  391. Updating a text field in SQL Server
  392. Sequence no group wise
  393. best practices for writing SQL server stored procedures
  394. avoid using cursors
  395. High Performance SQL Server (article)
  396. SBS 2003 Monitoring Database
  397. Beginning SQL Server Book?
  398. sql 2 tables ask
  399. problems trying to import data from excel file
  400. Procedures v. Functions
  401. Build ID w/Incrementing Digit
  402. Problems when trying to rebuild indexex
  403. Unable to connec to SQLSERVER server from client
  404. Detecting (local) sql-server
  405. don't understand the following locking behavior
  406. How to recover SQL database from a removed laptop hard drive?
  407. Create User Function w/Case
  408. Connecting to Webservice from DTS
  409. Changing lost SA password
  410. cannot edit text cell
  411. Create variables with same format in one single step?
  412. Loading db & Read-Only db
  413. Sql puzzle
  414. Convert RTF to plain text
  415. What is the best way to create a script to update a new version of a the DB
  416. Recommended Stretagy for Bi-Directional SQL DB Synchronization
  417. Local SQL Service Not Starting but SQL Server is running?
  418. DROP_EXISTING
  419. Help! - Query On Time Field In SQL Server - How?
  420. Representation for Heterogeneous Attribute Set
  421. MS SQL Server Service Manager does not find instance
  422. Basic SQL question...
  423. Performance of views accessed by multiple SPIDs?
  424. Retrieve Manager/Subordinate hierarchy from Self-Referencing table
  425. query that select extended procs
  426. using logins
  427. Connecting to SQL Server OVer Internet
  428. A Query Help!
  429. Linked Servers to Lotus Notes
  430. UPDATE a variable to different categories by a single step?
  431. When is procedure cache flushed or cleared?
  432. problems with a stored prc
  433. Local variables in stored proc
  434. FYI: a weird performance problem with MSDE and possibly SQL Server 2000
  435. Cleaning unused stored procedure best practice?
  436. Automatic Execution of a Stored Proceedure
  437. Uninstall second instance
  438. Log backups - what does a database name of 0 mean?
  439. WHILE loop speed compared to cursors?
  440. Ye Olde GUI display/sychronization problem...
  441. Can 98SE read files from NTFS Drives?
  442. Regarding a sample query
  443. SQl server connection from another location
  444. authorization error in reporting services on win2003
  445. Scan count
  446. Strange SQL Question
  447. SQL Server and Automated Emails
  448. Need advice on best way to make dbase record updates
  449. SQL Server BIGINT and MS ACCESS...
  450. What datatype to use for PK?
  451. SQL Server 2000 performance counter
  452. Is it MS SQLServer or something else?
  453. Log IP Address of attempted logins
  454. Accessing SQL Server Databases from Networked PC
  455. Error in store procedure
  456. relocating transaction log
  457. Advice on table design which will allow me to enforce integrity
  458. Database back end - SQL Server or Access
  459. .
  460. Optimization technique
  461. Store Gitar Codes
  462. New setup of MySQL on my machine....
  463. linked server referred by insert trigger
  464. How to dedicate a cpu for SQL Server?
  465. Database Setup and Design
  466. BCP and treatment of NULLs when export to fixed format text file
  467. How do I programatically acces a database with a '-' in the name?
  468. How to have a batch transaction?
  469. Strange OSQL behavoir.
  470. Now if a update worked in a SP
  471. Enterprise Manager Problem with registering connection
  472. ISO 6346 Check Digit Calculation in T-SQL
  473. Problem with Parallel Query Execution
  474. Varchar vs Char in 1st field of composite clustered index
  475. IN (subquery) slower than calculation @VAL and then IN (@VAL)?
  476. using application roles
  477. using application roles
  478. using application roles
  479. using application roles
  480. permissions to see design view
  481. using application roles
  482. Selecting the same column twice in the same where clause
  483. using application roles
  484. using application roles
  485. using application roles
  486. Select
  487. australian postcode db with longitude/latitude
  488. Replication and sql server 2005
  489. Copy permissions of a database role
  490. Compare datetimes
  491. select from subquery
  492. Chosing the right hardware configuration for SQL server
  493. Extended Stored Procedure - ODBC Loopback Connection Problem
  494. iif stored procedure
  495. Move Log File Locations
  496. sql server backup job timeout
  497. Data casting, casting operations
  498. Merge Repliction - Run Stored Procedure when merge agent starts
  499. Bring db online/offline
  500. WTD: Data Base/Application Needed
  501. SQL Server for data processing
  502. Winter SQL Server Gurus Event at UCLA
  503. Numbers and Crystal Reports 9
  504. Question: Date field
  505. How to update just one record
  506. online questionnaire w connection to database
  507. MSDE and ODBC Tables
  508. characters encoding
  509. Is bookmark in a nonclustered index ordered?
  510. Database server will not expand mdf or ndf files
  511. Imbedding a Select Statement within an Update
  512. How to update a table with SUM function?
  513. Vanishing parallelism
  514. Sort Results by Number of Hits
  515. Table Corruption?
  516. Is @@IDENTITY really unique in multi-sessions scope
  517. Extract data from SQL 6.5
  518. Odbc unstabil
  519. [22003][0][Microsoft][ODBC SQL Server Driver]Numeric value out of range
  520. SQL 2000 Physical Layout Question
  521. Gripe: interoperability
  522. Urgent Deliverable
  523. Passing Paramenter to SP for Column Name
  524. Using SQL Server (T-SQL) to parse text
  525. Conditional WHERE statement?
  526. Aggr
  527. When Export to Excel
  528. Record Locking in Access ADP
  529. Return rows where column is less than 10 characters
  530. Ordering varchar column numerically
  531. sql server database installs
  532. Error in connection with database
  533. Simple MAX query?
  534. Database Normalization/Design Question
  535. Reclain space after DROP COLUMN
  536. Adding Execute permissions on Stored Procedures
  537. large arrays, UDFs and the text datatype
  538. How to learn sql from beginning?
  539. SQLXML - Soap/Any Authentication? Exporting SQLXML IIS Settings?
  540. How to return large amount of data in the XML format
  541. Extract data in "Insert Into..." statement format
  542. Does Alter Column do work if column already the same as desired?
  543. ODBC in SQL Query Analyzer
  544. Inconsistent Database Performance
  545. Search for a field name in stored procedures
  546. MDF Disk Fragmentation - Backup and Restore
  547. How to tell if AWE is actually working?
  548. help with query
  549. Numeric overflow . No errors. Insert the wrong number
  550. How to add a do loop in sql? Thanks a lot!