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