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