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