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. large arrays, UDFs and the text datatype
  2. How to learn sql from beginning?
  3. SQLXML - Soap/Any Authentication? Exporting SQLXML IIS Settings?
  4. How to return large amount of data in the XML format
  5. Extract data in "Insert Into..." statement format
  6. Does Alter Column do work if column already the same as desired?
  7. ODBC in SQL Query Analyzer
  8. Inconsistent Database Performance
  9. Search for a field name in stored procedures
  10. MDF Disk Fragmentation - Backup and Restore
  11. How to tell if AWE is actually working?
  12. help with query
  13. Numeric overflow . No errors. Insert the wrong number
  14. How to add a do loop in sql? Thanks a lot!
  15. IsLogin problem
  16. List of Logins
  17. bcpinit problem
  18. Full Text Search - Ranking Algorithms
  19. Reindex maintenance plan fails after adding secondary data file
  20. 16 gig of memory (AWE or WSRM)
  21. Fastest way to execute aggegate functions on a table?
  22. How to determine if stor proc parameter is output or input
  23. Query Analyzer. Align/indent stored procedure script
  24. Help Needed!!
  25. importing and archiving
  26. Need details on Query Profiler
  27. How do you improve SQL performance over large amount of data?
  28. Particularly Challenging SQL Problem.
  29. how do you know indexes have been fragmented?
  30. How do I write a point-in-time record to another table?
  31. Capture Returned Value From Exec(@Build) into another variable
  32. sql query syntax
  33. Executing a DTS Package using an ASP (VBScript)
  34. Indexes and File groups
  35. Need help figuring out SHOWPLAN_TEXT help
  36. assigning each record to one string
  37. From excel file into MS SQL server
  38. JDBC: calling a stored procedure with multiple return values.
  39. Query joins problem
  40. Evaluating Lumigent Entegra
  41. Querying data from multiple views
  42. Reporting Services security issues
  43. Table export removes primary key
  44. Stored procedures and Visual SourceSafe
  45. Microsoft Exchange to Microsoft SQL Server
  46. Multiple Deletions From Different Tables in SQL Server Trigger
  47. database prioritizing
  48. How to copy Database Structure from one db to another w/o affecting data
  49. Query timeout problems
  50. Any easy way to change column length like varchar 30 to varchar 100?
  51. Any easy way to change column length like varchar 30 to varchar 100?
  52. Any easy way to change column length like varchar 30 to varchar 100?
  53. Any easy way to change column length like varchar 30 to varchar 100?
  54. SQL Server 2000 cannot listen on TCP/IP!
  55. changing the default value for a column
  56. Update remote table from local table
  57. integration betwenn Analysis Manager and GIS applications
  58. Determine which user has locked a record
  59. website problem with mySQL data base
  60. Two questions about SQL Server 6.5
  61. Running Cognos from SQL
  62. Disabling Named Pipes
  63. group by clause query help
  64. SQL Server Network Utility - where is it?
  65. SQL instances ports
  66. CommandText issue - SQL Reporting Services
  67. Index creation causes error "The conversion of a char data type to a datetime data type resulted..."
  68. Connecting to Sql Server from Application
  69. Incrementing or updating a TIMESTAMP field.
  70. BCP Large Table.
  71. Slow performance of like operator
  72. SQL Database design question
  73. Update Query (Access vs. SQL Server)
  74. Reporting Services security
  75. schema extraction for multiple interdependent databases
  76. Using Visual SourceSafe with Sql Server
  77. ETL: OLTP -> DATA Store
  78. ignored words in full text indexing
  79. Implementing read-write locks
  80. Poor Performance on Dual Xeon Machine
  81. How do I reinstall the SQL Server ODBC drivers?
  82. need help
  83. How stopping and restarting full text indexing?
  84. Solved
  85. Avoid caching image datatype
  86. How to get the date part of Datetime
  87. Possible?: Count(*) returned by EXEC
  88. Connection string OLEDB - SqlServer
  89. Help with query plez
  90. Sql Server ODBC applet won't start can't configure problem
  91. Query problem
  92. Replication with Triggers
  93. How To Round With Negative Numbers?
  94. Third party reindexing utilities
  95. Create table with 15,000,000 default rows
  96. Making a Stored Procedure in MS-SQL 2000
  97. Time Function?
  98. Can we use details hard coded into exe directly in reports without storing in DB
  99. Sql Server does not exist or access denied issue again
  100. Replication issue
  101. insert double quotes into sql server table
  102. SQL Using LIKE Command with Subquery
  103. Triggers and Replication
  104. RS ASP.Net code
  105. "organize and view datasets using toad"
  106. Very small table incredibly slow
  107. 6GB 2 row table????
  108. Question about debugging
  109. organize and view datasets using toad
  110. Quick question: how do I get the name of the current database?
  111. Collation problem with SQL 2000
  112. But the documentation is NOT correct
  113. Need to change IP address of server
  114. EXCEPTION_ACCESS_VIOLATION: Odd Error in Event Viewer
  115. Keywords
  116. Storing result of EXEC into a variable
  117. Concatenate String and Pass to FORMSOF?
  118. Performance problem while using Linked Servers
  119. Reporting Services
  120. Transposing?
  121. Database Administration Survey
  122. cannot add windows user, cannot delete sql user
  123. More than one column FOREIGN KEY constraint specified for column
  124. Manipulating the result set of one stored procedure from another....
  125. SQL Server Client tools installation
  126. DTA package handling multiple file formats
  127. Controlling Data Modification at row level
  128. Chicken and egg problem: FOREIGN KEY reference to a table that doesn't exist yet
  129. How to Add a Missing Index to a Table in Merge Replication?
  130. MSDE Performance Governor - knowing when its kicked in
  131. Default Stored Procedure Parameters
  132. SQL 2000 log shipping question
  133. HELP with SQL Statement...urgent!
  134. [ monografia Administração [
  135. Enterprise Manager appears to slow my dial up connection
  136. Basic SQL Question
  137. Combine matching multiple rows into one row
  138. Showing record rows in group by SQL
  139. Showing record rows in group by SQL
  140. Query Analyzer. Error : Unable to connect to debugger
  141. Delete rows from one table using rows from another table
  142. selecting changed rows only
  143. Alter table alter column in MSACCESS. How can I do it for a decimal field?
  144. SQL Server to Generate XML instead of Redendant Query..file open during write problem or job not running...
  145. linked server from sql 7 to ms access 2000 ... some tables not available - solved
  146. Linked Server Limit in SQL Server 2000
  147. Access Data Projects
  148. Concurrency, have I got this more or less right?
  149. Simple sort on a table...
  150. Dependency Info
  151. SQL precision arithmetic overflow error for numeric and decimal datatypes
  152. best jdbc 1.0 centric driver for sql server
  153. XML and Searching
  154. count rows question
  155. find out active Sql statements
  156. Update multiple fields Accross a Join
  157. Ext. SPs
  158. SQL -2005
  159. Multiple Databases and multiple exe for a single solution
  160. Case Statement Within A Select Where 2 or More Instances Of The Record Exist.
  161. SQL Server 2005 Beta 2 Transact-SQL Enhancement
  162. Multiples Instance of SQL server 2000/SQL server 7.0 on Windows server 2003
  163. Replication - Single Publication versus Multiple Publications
  164. Help me rid my curse... please.
  165. optional parameters passed to stored procedure
  166. Join the Result of xp_logininfo with a table
  167. Filtered joins
  168. How do I search for the same criteria in three or more fields in one table?
  169. Linked Server: WHERE clause not being executed
  170. URGENT - SERVER CRASH
  171. How to automatically replicate remote database which is not permanently online
  172. Stored procedure where clause
  173. how to report the size of each table in a database?
  174. Convert Rows to Columns
  175. Execute a Stored Procedure
  176. Finding Stored Procs that Ref/Update a column
  177. Dynamic Sql: Truncate Table: Trap @@ERROR
  178. Stored Procedure does not appear in the sysobjects table.
  179. Update / Delete with Joins
  180. Generating Multi Level nodes in Stored Procedures
  181. extended character search
  182. unique key with optional field
  183. DTS 2005 and quoted table names
  184. EXCEPTION_ACCESS_VIOLATION
  185. Finding dashes/hyphens in a column.
  186. Configuring mail for SQL Server Agent - Problem with Exchange and Outlook on same machine?
  187. Creating a directory command question
  188. How To Get Covariance Matrix
  189. Bit Value
  190. Get with the program
  191. Thanks all
  192. Help with insert into query plz
  193. Problem using Access 2000 as a front-end to SQL Server 2000 tables
  194. Query help joining 2 tables
  195. Index= <th scope="col"> ?
  196. Export from MSDE
  197. Rows in a table
  198. How to stored a stored procedure's results into a table
  199. Multi processor OS restriction?
  200. SQL query builder
  201. Scripting ALTER TABLE
  202. How to load a Unicode file into the database in the same order as the file order
  203. revoke permissions TO stored procedure
  204. Asking the user a question
  205. Iterating updated fields within a Trigger
  206. Report Server Subscriptions - Job Owner
  207. Dynamic evaluation
  208. crystal reports and Sql Server 2k
  209. Order By Case Cast Convert Error
  210. Customize Prompt Message for Stored Procudure
  211. Assertion Errors:
  212. Concurrent Access - New Record, Primary Key problem....
  213. Correct access to TempDB?
  214. Correct access to TempDB?
  215. prob with SQL script that work with Date/Time abd boolean
  216. Enterprise Manager Cannot Display Table Records or Run Query
  217. performance and locking problems - urget
  218. Simple Query Question
  219. Editing table data in Query Analyzer
  220. char vs. varchar
  221. Correct access to TempDB?
  222. MS SQL Reporting Services Server - Activation errors
  223. Passing control flags to stored procedure
  224. DTS Package - Append Results to Text File
  225. Collation problem
  226. ODBC via Windows authentication
  227. Connectivity issue - SQLServer not listening on port 1433/ms-sql-s
  228. Openrowset and mdb -Files
  229. A query where two tables are linked to the same another table
  230. sqlserver page
  231. How do I change the SQL server for Access ADP?
  232. Tough Date Manipulation Issue.
  233. Grabbing characters from a string
  234. Performance of extended stored procedures in SQL Server 2000
  235. Error 0: Timeout Expired HYT00 when trying to backup DB's
  236. Error 0: Timeout Expired HYT00 when trying to backup DB's
  237. Search query between two tables
  238. Is SQL Server SQL99 Compliant
  239. Split a column into 2 columns
  240. Querying date
  241. Subscriptions not working
  242. SQL Transpose Table
  243. Dynamic formulas driven by table
  244. Transaction across 2 databases?
  245. Practice test for 70-228
  246. Computed Column calculations
  247. SQL Delete prob.
  248. inserting one query before another
  249. ReportParameter.ValidValues
  250. MS Access front end to SQL Server problem passing Form value to Report
  251. Indexing question
  252. workstation sees 2 instances of the SQL Server?
  253. Execute DTS Packages
  254. SQL Losing Data
  255. Correct Table Structure - Optional Values
  256. SQL Server execution plans
  257. Feasability of storing PDFs and WORD.DOC files in MSSQL?
  258. DB and Log backup
  259. Wrapping query batches in a single transaction.
  260. Querying across databases on same server
  261. Search All Tables and Replace
  262. Question about procedures to create procedures in a different database
  263. Migration Tools For 2005 Express
  264. Can't unlock records in SQL Server
  265. Script / Function ... to find difference b/w 2 similar tables
  266. CREATE INDEX on large table
  267. tsql Substring question
  268. SUBSTRING question
  269. UPDLOCK on a mult-table join
  270. tsql Substring question
  271. MSDE 2000A
  272. how to update a datetime field
  273. sql server 2000 Table Maintenance
  274. What is expert SQL knowledge?
  275. toad for mssql problem
  276. They're invading my node!
  277. Deciphering deadlock information..Please help!!
  278. update versus rebuild
  279. stored procedures synchronization
  280. Scary Results
  281. Local cube with Parent-child dimension
  282. sp_executesql
  283. Stored Procedure Reuse
  284. Join syntax help
  285. How to include variable in CURSOR SQL Filter clause?
  286. Data modelling question
  287. Best way to send email from a stored procedure (dynamically changing paramenters and attachment)
  288. Bitwise question -
  289. Troubleshooting SQL Buffer Cache Hit Ratio
  290. Log File Full Stored Procedure Error
  291. Mysterious query problem?
  292. Storing result of EXEC into a variable
  293. Which collation name to use for a database that store Korean characters?
  294. A VoIP usergroup
  295. Optimizator and indexes
  296. How to find my previous topic??
  297. Stored Procedure Sebquery as a Paramater
  298. SQL fails after SP3a has been applied. Slammer?
  299. Restore SQL master database from a file
  300. Any Fuzzy Software ( Other than SOUNDEX / NYSIIS )?
  301. Backing online database table data to local machine
  302. re-insert / templating records
  303. looping through results of a OSQL query
  304. Comparing a column list split to a table.
  305. Replication - Can not create Publication database
  306. Troubleshooting needed
  307. Bad Query?
  308. Working with MSDE
  309. Optimal SQL
  310. Securing local MSDE applications
  311. Restore of Backup problem
  312. how to fine a hole in a records?
  313. SQL NULL or Value
  314. LoadFromSQLServer won't work......
  315. querying by date on smalldatetime
  316. Connecting to SQL Server 2000
  317. How To Access Visual FoxPro Data from SQL Server ?
  318. Automatically run a stored procedure at 6am every day?
  319. Stored Procedures - Help
  320. enable a trigger
  321. Unusually High CPU on SQL Server the 2nd day after a reboot.
  322. An interesting holistic question for the groupmind...
  323. Sleeping processes take a long time to kill-
  324. English Query
  325. Strange datetime conversion error in stored procedure.
  326. Changing physical SQL Server
  327. Word Update
  328. Database Replication
  329. Database marked as suspect please HELP!
  330. Large amount of pages for few rows
  331. Data checking?
  332. Design Question
  333. SQL Server 2000 Service Pack 3a installation fails
  334. Replication(Publisher-Distributer Problem)
  335. New login cannot retrieve data from db
  336. Create a database login in the default domain
  337. New login cannot retreive data from db
  338. New login cannot retreive data
  339. Why no access to db table?
  340. Best way to keep track of SQL Server Changes
  341. XML output serialized for remote query
  342. Starting the SQL Service through Enterprise Manager
  343. Best practice for Data size/Log Size ratio
  344. Collecting Active Directory dates
  345. transaction question
  346. Does the client have to be running IIS??
  347. Question on generating SQL scripts using Enterprise Manager
  348. Can't trap sql errors using ADO (DTS ActiveX task)
  349. Backing up design changes
  350. Backing up design changes
  351. Maximum user connections?
  352. ORIGINAL SIN IN SQL 2005!
  353. Log Shipping - false alerts, real problem...
  354. Connection Problem with the Workstation
  355. Insert Trigger Help
  356. SQL Agent Job Fails Immediately after Invoked
  357. Potential issue with DTS and Log Shipping
  358. Transfer from 2000 to 7.0 - what can be done?
  359. Checking backup file questions
  360. How to query for records that have not been replicated
  361. still not clear
  362. What happens to Windows Authentication if domain failure occurs?
  363. Datepart query example help needed or something else??
  364. Connection Failed
  365. Is it possible to save and force a plan?
  366. MDF and LDF files size command
  367. SQL "Commandments"
  368. Sql View
  369. Database Design Question
  370. Can a stored proc swallow an error
  371. nocount on problem
  372. Intensively used function in view needs a minimum and maximum from a table PartII
  373. problem using ntext data type in OPENXML
  374. How can I get c# text and use as parameter?
  375. Any way to easily add this computed column (divide by zero problem)
  376. securing db access
  377. SQL Server: Backup/Restore
  378. ListAvailableSQLServers Problem
  379. Can't Get Decimal to Show Up!
  380. Why two different views?
  381. Why two different views?
  382. Backing up and restoring SQL Server
  383. PDF Bookmarks
  384. t-sql alter table udf help!
  385. SQL server log file is not shrinked
  386. Select on large table.
  387. Second call: third edition of SQL FOR SMARTIES
  388. executing DTS - DSN error...
  389. sql server & crystal reports
  390. ASP COM and database access
  391. Insert and Update Trigger on same Table
  392. Releasing resources on the server
  393. Can I integrate a "reporting services" report into c#.net app?
  394. HELP! Non-Replicated DB thinks its a Publisher
  395. Database authorisation problem
  396. help with error handling
  397. Getting my finished SQL Reporting Services report in my c# project to view it??
  398. connection problem - windows 2003 +sql2000
  399. Query to find what is not there
  400. why is execution of a storedprocedure in QueryAnalyzer faster thanexecuting this SP as scheduled job?
  401. Intensively used function in view needs a minimum and maximum from a table
  402. MSMerge_tombstone cleanup
  403. List of SQL Server Users
  404. List of SQL Server Users
  405. Resources used by UDF
  406. transactional replication - re-syncing publisher from subscriber after failure
  407. Help: Update Query with Linked Servers
  408. Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
  409. not associated with trusted SQL Server problem - windows service
  410. converting queries from Access2k to MsSql2k
  411. GWUTIL.DLL
  412. Q: DTS and global variables
  413. Need Customer & Sales Database Designed /for Internet Sales Business
  414. Need Customer & Sales Database Designed /for Internet Sales Business
  415. Need Customer & Sales Database Designed /for Internet Sales Business
  416. Need Customer & Sales Database Designed /for Internet Sales Business
  417. Incorrect Date Conversion - Help Please
  418. SQL field sep question
  419. Connecting to MSDE w/read only file?
  420. Update Versus Append
  421. Blogs
  422. Design
  423. Creating a common table expression--temporary table--using TSQL???
  424. Q log shipping
  425. No buffers
  426. sql server job output file -passing it onto second step
  427. Reference for Security Nazi's
  428. move a database
  429. Database not Shown
  430. Creating Database in OSQL Error
  431. Hints
  432. View Diagram Pane - how save layout after I change it? 2000
  433. How to correctly propogate data back to the database
  434. sql server 2000 installation problem
  435. DB design question - survey system
  436. Create Database by using OSQL
  437. SA Password?
  438. Client/Server Connection
  439. Execute windows on client machine
  440. group by clause Query help
  441. Comparing two sets of data
  442. Log all connections to a SQL Server
  443. Classification crosstab query - 2000
  444. SQL Server 2000 and Windows 2003 SBS
  445. master db restore
  446. Convert 1084313300 (Ten Digit) value to Datetime
  447. osql timeout
  448. ODBC
  449. Securing Databases From Porting
  450. is there a quick way to get a list of roles a user is a member of?
  451. Modified Date For Stored Procedures
  452. SQL job and login
  453. Which one of these SQL Monitoring tool is the best?? Please advise..!
  454. Order of Joins and Performance
  455. tempdb and templog - moving
  456. tempdb and templog - moving
  457. Changing the day of week in SQL Server 2000
  458. Porting from oracle to SQL Server
  459. Running SQL Server 6.5 on Win2K Server??
  460. SQL Client & Licensing
  461. Help with Stored Procedure
  462. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  463. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  464. DTS data from MS SQL 2000 to DB2 7.1 on OS/390
  465. Fix: T-SQL Debugger in Query Analyzer and Visual Studio breaks when Windows XP Service Pack 2 is applied
  466. timeouts!!
  467. where to find comments property
  468. Merge Replication
  469. How does adding constraints affect performance?
  470. SQL Server Express setup snafu
  471. Truncate Database Statement help
  472. MSDE 2000 On Windows 98 SE Installation
  473. SQL Server 2000 Cannot Restore
  474. Some comments on DTS package
  475. alter column fails due to statistics
  476. SQL-DMO: SQL Server Agent properties - Mail session - Mail profile
  477. Help with SQL stored procedure
  478. Mutually exclusive counts on ordered queries
  479. sqlmaint.exe failed when backup db
  480. Install Enterprise manager without install sql server
  481. use function from asp file in stored procedure
  482. Altering table & trans. replication
  483. "Microsoft SQL Servers" not showing in Computer Management.
  484. DAO and SQL server
  485. DTS Text Import Question
  486. secret text messaging for a DBMS?
  487. How to use BETWEEN with custom-ordered values
  488. problems running memory intensive queries
  489. Lost sysadmin, but I still have it???
  490. SQL View/Table question
  491. Designing a database within a database... design question storing data...
  492. SQL Analyzer
  493. Identity columns
  494. UML and SQL
  495. ExecuteWithResultsAndMessage2 SQL-DMO and perl
  496. Can you filter SELECT results?
  497. DELETE problem
  498. I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS
  499. How to customize view of SQL Server Enterprise Manager on startup?
  500. Execution of script at login
  501. Job failure notifications for non-administrative users
  502. WHERE
  503. import multiple accessfiles in dts
  504. Access migration to SQL Server
  505. Why xp_sendmail Doesn't Work With Hotmail?
  506. Constraint question
  507. Connecting to online database using local Enterprise Manager
  508. MySQL vs SQL Server?
  509. export data without trailing spaces
  510. Tricky Case Sensitive Query on SQL7
  511. Obtaining the version of ADO installed on XP
  512. How do i replicate data from MySQL into SQL-Server
  513. Let your customer find fast and easy all text he searches !
  514. How to Identify user defined data types
  515. insufficient memory to run this query
  516. sp_who2 displays funky CPU usage on pentium4 server
  517. Easy to Say but hard to implement
  518. Easy to Say but hard to implement
  519. Ascending and count help
  520. Query Analyzer locks up!
  521. Task/transaction token by logging
  522. Is there any third party s/w that lists SQL servers in a network and query more info about the server?
  523. Is there any third party s/w that lists SQL servers in a network and query more info about the server?
  524. SQL Triggers: Transfer Data from SQL Server 2000 to Visual FoxPro DBase
  525. Slow Insert - Help?
  526. Slow Insert - Help?
  527. Help with Slow INSERT - MS SQL 2000 - Help?!?
  528. Cluster /AWE / 3GB Switch /Memory Usage
  529. How to get SQL Server Info(Version/SP Version/Server Statistics) from a network.
  530. SQL Function to convert RTF to plain text
  531. could not open the file for reading. close any other application that may be locking the file.
  532. Data modeling question
  533. Replication
  534. Stored procedure performance mystery
  535. Select Into works, Create table does not
  536. Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format
  537. SQL Clusters and Analysis Services DSO
  538. Pratical size of a SQL Server database
  539. Adding DEFAULT columns
  540. password in a Table
  541. Distributed Transaction takes far too long
  542. database recovery
  543. SQL crosstab results in numbers on the 'diagonal'
  544. Query for percentage of a SUM
  545. sorting problem with linked server
  546. Running out of Sql Connections
  547. Instead of Delete in replication
  548. DTS file name to include System Date/Time
  549. Possible DTS File Import Bug
  550. Merge two rows in the same table