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