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