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. sql data value unrecognized
  2. Optimizing a big query
  3. Backup fails using SMO with big databases
  4. Full date value not being written via JDBC - any ideas?
  5. create table
  6. Stored procedure returning wrong value because of ANSI_WARNINGS
  7. Effective permission for a group
  8. how to normalize
  9. compare in database
  10. Need advice on system performance
  11. xp_cmdshell sql server 2000
  12. Column update structure change
  13. Need help running query on data/time field
  14. odd stored procedure behavior
  15. RE: Combining multiple databases into one
  16. Can this deadlock issue
  17. Locate rows in table where column value missing (I think!)
  18. Why optimizer is not smart? Is dynamic SQL my only option...
  19. Date function
  20. Wifi Barcode scanning -- need middle ware help
  21. Dynamic SQL does not work!
  22. Sql Server Enterprise manager and stored procedures
  23. SQL Server 2005: Unable to add SQL2000 subscriptor using non-standard port!
  24. web service in MSSQL
  25. APIs for monitoring MS-SQL
  26. Connecting SQL 2000 using SQL 2005
  27. how to check sql port
  28. Exporting sql server database
  29. Monitoring memory usage
  30. Using parameter on Query condition not working
  31. Link Two tables
  32. Stored Procedure querying another database
  33. Query RowVersion in SQL Server 2005
  34. Increase speed when retrieving data from a Hosted SQL SERVER into VBA
  35. looking for a consultant
  36. "insert on existing update" in MS SQL Server?
  37. Users Can see all the Database
  38. NULLS and ''
  39. SQL job error
  40. @@Error not catching error.
  41. Migrating SQL logins with password
  42. sql server 2000 in window service
  43. Uargent Oracle-DBA professionals required
  44. T-Sql for changing the Owner of the table objects in a database
  45. Exporting data from SQL table to Excel File - How to delete rows before inserting new
  46. great tool to compare data from two different queries
  47. Stored procedure and SQL Job Agent Task
  48. MS SQL using TSQL via JAVA jdbc
  49. use of union in indexed views
  50. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  51. "ODBC--call failed" Error
  52. Need help writing T-SQL statements?
  53. Problem: Performance difference between MSDE and SQL Express 2005
  54. Using DTS to migrate Access ot SQL Server
  55. Print data through Store Procedure
  56. Using LIKE in a CASE statement
  57. I don't understand this "server timeout"
  58. Doubt about SQL Server
  59. creating backup of MS SQL database
  60. VB Code to BackUp Data from SQL to Access
  61. SQL Server does not exist or access denied
  62. replacing join operation in XML
  63. Bulk Insert
  64. Noise words issue in full text seach Sql server 2000
  65. How to remove rows where only part of the row is duplicated
  66. SQL Slow from MSDE 2000 to SQL Express
  67. SQL a range in the all dataset
  68. any way to debug stored procedures without buying visual studio?
  69. Ansi SQL92 question
  70. SQL Collation Problem
  71. Why transaction gets promoted to Distributed transaction
  72. monitoring applications querys
  73. How may cause Record disappearing from table ???
  74. MS SQL 2005: Where clause and optimizer
  75. Software Developers/Programmers
  76. How do I determine the backup date of a restored Database..?
  77. filtering data correctly?
  78. Trouble with getting this query
  79. SQL Server 2005 order by date does not sort properly
  80. Getting a count from multiple columns
  81. why i can't post message here? tried twice.....
  82. bcp and trigger: missing data in bcp out file
  83. bcp & trigger: got missiing data in bcp out files
  84. Querying towards a responsive UI
  85. Arcserver 7 Backup With SQL 2005
  86. SQL Query - Newbie help with summaries
  87. Need help with error 17137
  88. I need SQL Query Help
  89. extract data from SQL .mdf file?
  90. How to Execute a Query Stored in a variable in Stored Procedure
  91. Failing to launch
  92. Database security
  93. urgent requirement for project leader/apm required
  94. BCP error - missing data
  95. BCP error - missing data
  96. Help With complex SELECT
  97. SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases
  98. Update Statement
  99. Varchar to Integer Typecast
  100. HELP! Synchronize db and maintain foreign key relations?
  101. T-SQL, Cursors, Best Practices of pulling from multiple tables
  102. DTS and SOAP Web Service
  103. 10080 sql server 2005 configuration caused error?
  104. DTs and Buisness Intellegence
  105. filter data by row number
  106. Create DTS package validation
  107. SQL Server CE
  108. Updating online SQL 2005 database from local database
  109. how to compare value of two fileds and based on that insert value into third fileds
  110. select a data from sybase table to sqlserver 2005(its urgent)
  111. how to use rowcount to delete rows?
  112. 1st Image Control Shows Wrong Image
  113. Bulk insert rollback
  114. How to auto-generate age field when DateOfBirth is given in SQL Server.
  115. JOIN columns question???
  116. intermittent OLE DB error
  117. sending email from SQL Server 2000
  118. Turn OFF identity property
  119. SQL DTS Transform Task - new output table
  120. How to Design and Handle a Table with 30 Million rows
  121. Storing SQL Server 2005 objects and queries in Perforce
  122. Maximum Numbers of Tables and colums to access in select statement
  123. Hi.. friends get set go is my position
  124. Query Time Out Expired
  125. Executing Stored Procedures
  126. Convert FLOAT to NUMBER without DECIMAL PLACE
  127. using count to filter data
  128. Selecting from a stored procedure
  129. Can't Connect to Database Engine
  130. Violation of PRIMARY KEY constraint...Cannot insert duplicate key Problem
  131. Making Inegration Services visible/available in SSMS 2005
  132. a q about counting
  133. Transferring databases from MSDE 2000 to SQL 2000
  134. backup/restore of Tables ONLY (please)
  135. Setting recover model with TSQL
  136. Specified SQL server not found. [SQLSTATE 42000]
  137. Inexperienced with Queries
  138. Update bad addresses
  139. sql 2005 - optimization - cannot use index
  140. Query Help
  141. Editor with visual SCC / TFS support ?
  142. Input Paramter as part of OPENDATASOURCE
  143. Varchar Truncation
  144. Paging records on SQL 2000 : Followup question
  145. The age old argument of Temp table vs Table variable
  146. downgrade SQL2005 to SQL2k - Unicode ANSI issue
  147. Same table query
  148. Find all jobs scheduled between two dates
  149. Determine MS SQL License Mode on Wintel Servers
  150. Problem in SQL 2000 2136 The limit set by NX_SQL_QUEUE_LIMIT of 50 has been reached
  151. copy data from MSDE to SQL Server
  152. Disappearing output parameters!
  153. Words suggest or spellcheck in MS SQL 2005 Express
  154. sql server error
  155. Saving ER diagram on SQL server
  156. script to copy logins and users with all permissions
  157. Log Shipping on SQL Server 2005 Developer Edition
  158. Find Partial Text From Return Of Subquery
  159. Save your data schema and SQL statement to mSQL.mdf
  160. Paging records on SQL server using derived tables : more question
  161. HCL HIRING DATABASE ADMINISTRATORS - NOIDA . INDIA
  162. Connecting an ADP to a remote MSSQL database on the same network
  163. Insert into tables - many to many relationship
  164. transaction log files clear
  165. MSSearch Owning CPU because of FT Catalog.
  166. Subquery in SQLServer
  167. automatic number increment in ms sql 2005
  168. Paging records on SQL server using derived tables
  169. Things I didn't know until today
  170. Accessing remote MS SQL databases from PHP web pages
  171. stored proc or something else
  172. Problem with Restore (SQL 2005)
  173. Difference between Enterprise Manager and Query Analyzer
  174. Dynamic Query
  175. DROP Database sql server 2000
  176. Crystal Reports for VS 2005
  177. Problem Store Procedure in OutPut Parameter
  178. Generate XML File in SQL Server 2005
  179. DTS question reguarding text import and tranformation
  180. SELECT statement - How to not get column field names?
  181. Ignore-this is a test
  182. quick date conversion - not hard!
  183. SQL Server 2005: Using SQL to find the last time a table was written to
  184. JDBC ResultSet and cursors
  185. Turning Rows into Columns
  186. Problems with using Variables in place of Nested Queires
  187. Giving values to multible Varibles with SET and SELECT
  188. list all tables in master
  189. SQL Replace in Replace
  190. Issue with DB on particular machine
  191. what diff between procedures an triggers
  192. y use procedures
  193. inserting from a virtual table
  194. SQL 2000 examz
  195. MS sql server Problem
  196. How to get last records in grouped query.
  197. Problem with view
  198. Problem with view
  199. CONTAINS clause with multi-word "AND" inflectional searching??? help...
  200. Using Variables inplace of nested Queries
  201. SQL-Access Help Please!!!!!
  202. Where is the SQL Server Management Folder located?
  203. updating two tables
  204. UDF and persisted column
  205. using a count to filter excess data
  206. Bi-Directional Data Sync between SQL Server and Access DBs
  207. To find out which stored procedure is using a particulat table
  208. Network error while connecting to the Database through sql server 2005
  209. Combine two databases
  210. Stupid Question: Joining Strings
  211. Multilingual Table
  212. Update table using partial word match
  213. Match your Design site's data schema and SQL statement to Application site
  214. Server Error
  215. SQL query Syntax
  216. Design phase - dealing w/ many to many relationships
  217. Architectural question
  218. Encryption tutorial for SQL Server 2005 Express
  219. xp_cmdshell from within a trigger on SQL 2000 SP4
  220. Any idea what the purpose of this SPROC might be? (no prizes, sorry!)
  221. sql code for UML composition relation - anyone?
  222. shrinking a table of database
  223. Reporting Services
  224. SQL Statement to return first unique record
  225. Problem with Full Index Search
  226. price formatting
  227. DB2 --> 2005 Linked Server Mystery Solved
  228. Row triggers equivalent in sql server 2000
  229. Need a fixed-length table
  230. How can I sum the Case Statement?
  231. SQL Server 2000 and Milliseconds (datetime data type)
  232. Is this query possible?
  233. View definition includes no output columns or no items in the FROM clause.
  234. Query which calculates a field value based on previous row's values
  235. Link two tables using partial word match
  236. delete old files
  237. Query Question
  238. Issue with CONTAINSTABLE statement
  239. Beginner question: find or create function
  240. DTS Save Package dead end
  241. HOW to check for last modified time of a table Structure in SQL Server
  242. Job to be run ever first for the previous calendar month
  243. linking tables from other databases?
  244. Multiple rows into one row
  245. SQL Server on production very slow
  246. Disappearing Records
  247. New SP vs parameters
  248. Domain logins to a SQL 2005 Server User Rights Assignment
  249. SQL Server 2000 SP4 not importing stored procedures
  250. Try to use ROBUST PLAN. Somebody help?
  251. NVARCHAR Search Problem using LIKE
  252. SQL Query question. what's wrong with this query?
  253. MS SQL Server 2000 installation problem
  254. Trusted Security in a Workgroup
  255. Correct Schema for this business problem?
  256. MSSQL Trigger
  257. (pas de sujet)
  258. MS Reporting Services
  259. How To Aplly Check Constraint
  260. SQL server lock issue
  261. Stored Procedure / Cursor Help
  262. SQL server lock issue
  263. Inserting nulls in to table conflicting with rule
  264. Saving my MS SQL Query results in a spread sheet or CSV file
  265. Regd SQl server Enterprise Manager
  266. purpose of writing dates in this format
  267. ALTER DATABASE statement with Table Partitioning (SQL 2005)
  268. Auditing:Extracting changed fields from Inserted table
  269. Calling a script within a script
  270. Go and goto in one sql script gives error label not declared
  271. Round .99 to .00
  272. DTS - Schedule - Filepath - Permissions denied
  273. Login failed for user <servername>\<aspnet> error!!
  274. Text for Stored Procedure
  275. How Can i know how many USERS are in agroup.
  276. Group by returning multiple data
  277. Why is a simple WHERE clause so slow?
  278. 2005 Copy database objects from one server to another
  279. Count Item function
  280. How can I modify a report in Crystal Report 7
  281. Interesante relacion
  282. Stupid timing question
  283. Packages in SQL Server
  284. Trying to calculate from most recent of duplicate records in MSSQL
  285. Extended Stored Procedure
  286. can't alter function
  287. System resource exceeded (SQL / Access Application)
  288. Alem
  289. stored procedures
  290. msde data migration
  291. how to login from VB into sql server
  292. Bizarre slow query problem (again)
  293. SQL Server Script to get Date Format
  294. Restoring databases
  295. Bulk Insert - Fixed Length File
  296. Could not obtain information about Windows NT group/user "Domain\username" error code 0x5.
  297. Suppress Repeating Data in SQL Report
  298. Log Shipping - Move DB Changes?
  299. URGENT : SQL Return Code: -25001
  300. getting top 10 by group
  301. Sql Server (no items) - Over TCP/IP
  302. giving a proc database and table names as parameters
  303. Querying different databases
  304. max date select stmt problem
  305. 'aging' tables
  306. Convert Char To Datetime
  307. LInk two tables from two databases
  308. About deleting old files from a folder
  309. Creating functions
  310. to transfer data from a datagrid output yo a table in sql
  311. Visa Encryption with Sql Server
  312. Calling a Proc From a Proc
  313. to transfer data from excel to MS SQL
  314. Help with displaying information not booked on a certain date.
  315. INSERT special characters into SQL Database (Protect my Tic)
  316. Redefining an auto-generated primary key constraint name
  317. Unable to attach a database in SQL Server 2000
  318. Checking Table dependancies fron Store Procedure
  319. INSERT INTO using SELECT and values, and inserting multiple rows
  320. OLAP Calulated Measure Total Error
  321. Max Length of "Text" and "Varchar"
  322. Delete rows from one tbl based on whether row in another tbl?
  323. Default owner using ALTER AUTHORIZATION
  324. Simple SQL Server Question -- Is space within column name allowed?
  325. UPDATE a table with aggregate results for multiple columns
  326. Count the number of rows in a UNION ALL statement
  327. SQL database connection
  328. Damn! SQLServer2000 can't add a NOT NULL COLUMN even in one empty existing table!
  329. Connection from ASP page to SQL Server Express
  330. Autonumber field
  331. How to improve the performance of a query?
  332. stored procedure to concatenate column value sin a single cell?
  333. SQL server alert systems?
  334. Link Server doesn't work except through query analyzer: MSSQL freezing / timing out
  335. How to stop query in QA from continuing
  336. Idea: new database object that defines a FROM clause
  337. Splitting Full name data to First, Last
  338. Using Variables in Order By Clause
  339. Creating A Trigger
  340. How do I reference a table in one database from a SQL script running in another database?
  341. Select Subquery Filtering out problem
  342. How to automate deletion of oldest rows when table reaches certain number of rows?
  343. Import flat file into SQL Server 2005 Express
  344. set multiple procedures to execute
  345. Select max value of each group
  346. Removing Name pipes
  347. Should you perform maintenance on System databases?
  348. Using Local Variables In A Stored Procedure
  349. INNER JOIN/Index Threshold?
  350. Adhoc vs PROC
  351. BCP import with Blank lines in text file
  352. Linked server between sql server and oracle
  353. BCP import text file with blank line at end of file
  354. Datetime conversion problem
  355. display sql datas in xml file with stylesheet
  356. send mail from sql
  357. Help needed with trigger
  358. Weekday names
  359. Delete Duplicate Rec
  360. constraints of the attributes of a table
  361. Alter more than one view
  362. Merge Replication and Trigger Problem
  363. recovery
  364. How to find a lower date
  365. DTS Local Package
  366. Sp_executesql with Dynamic SQL string exceeding 4000
  367. Perfmon - improved tools
  368. Filtering on parts of a date/time field
  369. Need help refining lengthy re-iterative (looping) query
  370. database creation in XP
  371. any doc-tool for SqlServer?
  372. user defined function problem
  373. SS2000 shows password in icon tooltip
  374. execute xl macro within DTS 2000
  375. SQL Problem. The log file for database...
  376. sql server6.5
  377. ssis issue
  378. SQL 2000 and SQL 2005 together
  379. vb.net/sql proficiency
  380. Capture CPU Utilization in TSQL
  381. design question
  382. Problem with Updatetext in SQL 2000 trying to concatenate multiple text fields
  383. Changing a BIT to an INT where there's a CONSTRAINT and a DEFAULT
  384. many tables vs one big table
  385. Getting record count
  386. temporary tables
  387. Custom Ordering question
  388. PIVOT
  389. does ms sql support two phase commit protocol
  390. Bulk Insert Questions
  391. SPID in Blk By is itself
  392. argue why sql2005
  393. when to use fully qualified names ([database].[schema].object)
  394. Which SQL Server
  395. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32
  396. Crosstab. 2 totals ?
  397. Connection SQL Server 2005 with DNS hostname mismatch
  398. Time Intervals
  399. Hi Sashi
  400. Insert query firing Insert & Update trigger at the same time.
  401. Inserting into a text field in SQL Server 2000
  402. SS 2005 Express- Allowing null values and Foriegn Key Constraints
  403. Slow using compute command
  404. url cannot be found
  405. How to use SQL Server to keep track of remote site DB2 table update?
  406. Picture in database
  407. Document Search for CMS
  408. Convert from Access to SQL Server
  409. drawbacks of full text search of sql server 2005
  410. Question: re-associate dbo with sa??
  411. Replacement for my LIKE Clause
  412. New record results in blank foreign key in subform
  413. Site Search Code Help
  414. putting names of objects to control-flow loop creating objects
  415. Only functions and extended stored procedures can be executed from within a function
  416. how to try-catch 'sp_addrolemember'?
  417. server version
  418. Generate LOG file
  419. Bitwise
  420. Dba Issues
  421. sql server 2005
  422. clustered index
  423. help me plz!!
  424. Connections
  425. Calculating Trigger Syntax
  426. Selecting last date
  427. combine separate date & time fields into one datetime field?
  428. Dynamically Changing the length of a varchar(n) field
  429. DBCC Shrinkfile
  430. Fetch Query that triggered the TRIGGER
  431. ORDER BY CASE
  432. Sql server is not running
  433. Script to combine multiple rows into 1 single row
  434. How to search binary fields?
  435. protecting functions from view it
  436. Stored Procedure Range Not Working
  437. SQL Server CE and VS 2005 EE
  438. Dts (ms Access To Ms Sql Server)
  439. upload database to remote server
  440. Problem with trigger
  441. Comparing Date to SQL Server Date
  442. removing chr(13) and chr(10) from SQL
  443. SQL coulmn comparison
  444. Export Data in a specific format
  445. Writing file from SP with text column
  446. date format default for xp_cmdshell
  447. [scripts] prompting user
  448. Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts)
  449. The Process Could Not Log Conflict Information
  450. Need popup window whenever any updates
  451. FUNCTIONAL TESTER
  452. sp_executesql vs. EXECUTE
  453. if exists condition..
  454. Security Tips
  455. Reporting Services/Report Manager
  456. normalization
  457. PHP5 and SQL Server- Help!
  458. Problem with passing password to sqlcmd
  459. Compare Zero,NULL and one without if condition
  460. Problem with CCommand::Open when query str is too long.
  461. 2-3 words in field name
  462. Procedure to send an email to a customer using procedures in SQL Server 2000
  463. string function
  464. Security warning when running SQL Server query within an HTA
  465. SQL Auditing
  466. Retrieve Identity Field Value from a stored procedure into a form
  467. pagefile and memory advice??
  468. Max. number od users in SQL server
  469. SQL 2005, "build" scripts?
  470. Programically backup sql server database
  471. Conditional query results
  472. A question about an error message
  473. Hi Guys,
  474. Timing a trigger or a procedure to execute In SQL Server 2000
  475. a question about Exec
  476. Replacing NULL value in multiple columns in a table
  477. Help-Can I use 4 GB memory by SQL Server2000?
  478. file group decisions
  479. DTS: MSSQL 2000 DTS abruptly exits after clicking Define Columns
  480. xp_cmdshell
  481. SQL 7 to SQL2000 Upgrade
  482. Split Data file into multiple file groups..!
  483. Help!? Combining SQL Queries? Can it be done??
  484. Permission denied trying to delete user
  485. Weird millisecond part of datetime data in SQL Server 2000
  486. SQL 2005 Express with Advanced Services: missing providers
  487. SQL 2000 Stored Procedure move
  488. Dts
  489. insert record in a table with 'identity' constraint on it ... ?
  490. Need help in writing SQL stored procedure
  491. Need help in SQL stored procedure
  492. migrating access to SQL
  493. Advantages/Disadvantages to using more than one database
  494. create a table frm another
  495. Convert AlphaNumeric to Numeric
  496. Unable to Display Image Loaded into SQL Server
  497. printing messages with a Stored Procedure
  498. View Order Dissappearing
  499. How to create the ER Diagram for SQL Server Database objects
  500. Execute proceduers from another Proceduer with error handling
  501. Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
  502. Don't want Trusted Connection option...
  503. Reporting Services Excel Export
  504. max degree parallelism
  505. only authorized users can access the database in enterprise manager in MSSQL Server
  506. OPENROWSET and network share
  507. Restore .mdf file
  508. Top 5 rows
  509. Security issues in SQL Server 2005
  510. Help with joining records
  511. Opinion about design needed (splitting string data)
  512. Inner Join Problem
  513. SQL can it be done ?
  514. getting length of 8 characters
  515. Converting XML Reader to SQL Reader
  516. SQL Trigger to output to a text file
  517. Data out of range error
  518. How do I find out how full my files are?
  519. How to match records on several substring functions
  520. Backup Priority level
  521. Query help please
  522. Missing the zero (0)
  523. How to connect sqldatabase to the project ctreated in .NET 2.0.
  524. SQL Search Engine
  525. Can't connect to SQL server Northwind database
  526. Problem after Restore
  527. please, how to realize generalization in sql server database
  528. Ssis
  529. Problems with "SELECT USER" - Result always dbo
  530. how to display separate field after a condition
  531. Converting a varchar to int
  532. SQL2005 Default accounts
  533. odbc-timeout error on a linked table from Access2k
  534. Laws and Myths of Usability & Interface Design
  535. view and table
  536. backup
  537. status help
  538. Alter Table
  539. Overlaping time intervals calculations
  540. asdb - what is it? Shold I back it up?
  541. Need to convert cursor
  542. Database Migration from MS SQL Server 2000 to DB2 on Z/OS
  543. Order By Start_Date
  544. Migrating MSSQL2000 to MSSQL2005
  545. Urgent....please respond
  546. Caculated Fields in a Query
  547. Northwind - execution plan bug? Why Index Seek and no Bookmark Lookup?
  548. Querying information between two values
  549. How can you track user actions in a table?
  550. How to calculate response time.