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